package com.ruoyi.web.controller.tool;

import java.util.*;
import java.util.stream.Collectors;

import cn.hutool.core.collection.CollUtil;
import cn.hutool.extra.pinyin.PinyinUtil;
import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.common.core.domain.entity.SysRole;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.system.domain.SysRoleMenu;
import com.ruoyi.system.domain.SysUserRole;
import com.ruoyi.system.mapper.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.utils.StringUtils;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.media.Schema;
import io.swagger.v3.oas.annotations.tags.Tag;

/**
 * swagger 用户测试方法
 *
 * @author ruoyi
 */
@Tag(name = "用户信息管理")
@RestController
@RequestMapping("/test/user")
public class TestController extends BaseController {
    private final static Map<Integer, UserEntity> users = new LinkedHashMap<Integer, UserEntity>();

    {
        users.put(1, new UserEntity(1, "admin", "admin123", "15888888888"));
        users.put(2, new UserEntity(2, "ry", "admin123", "15666666666"));
    }


    @Autowired
    private SysUserMapper sysUserMapper;

    @Autowired
    private SysDeptMapper sysDeptMapper;

    @Autowired
    private SysRoleMapper sysRoleMapper;

    @Autowired
    private SysUserRoleMapper sysUserRoleMapper;

    @Autowired
    private SysRoleMenuMapper sysRoleMenuMapper;

    private List<String[]> buildEmployeeArrayList() {
        List<String[]> employeeList = new ArrayList<>();

        employeeList.add(new String[]{"综合管理部", "刘成林", "男", "140102197308182316", "18636162822"});
        employeeList.add(new String[]{"太原业务中心", "刘永生", "男", "140322197102217217", "13603560288"});
        employeeList.add(new String[]{"太原业务中心", "周志强", "男", "140102197811200614", "13313512360"});
        employeeList.add(new String[]{"太原业务中心", "李杰", "男", "142301198509125415", "18636125579"});
        employeeList.add(new String[]{"太原业务中心", "张晓丽", "女", "140111197212021629", "15934115111"});
        employeeList.add(new String[]{"长治业务中心", "申俊红", "男", "140402196510032014", "13903459365"});
        employeeList.add(new String[]{"运城业务中心", "马荣新", "男", "140802197303100017", "18935069019"});
        employeeList.add(new String[]{"晋中业务中心", "王红卫", "男", "142401196611221418", "13513545600"});
        employeeList.add(new String[]{"阳泉业务中心", "陆继武", "男", "140302196803290812", "18903533319"});
        employeeList.add(new String[]{"临汾业务中心", "冯智勇", "男", "142625196701040014", "13703572579"});
        employeeList.add(new String[]{"吕梁业务中心", "曹晓勇", "男", "142331196808011011", "18903581469"});
        employeeList.add(new String[]{"党建部", "徐静", "女", "140103197506031523", "13753184316"});
        employeeList.add(new String[]{"财务资产部", "孟存玲", "女", "142625197201070027", "13803498782"});
        employeeList.add(new String[]{"忻州业务中心", "郭庆生", "男", "142201197109309178", "13935000756"});
        employeeList.add(new String[]{"长治业务中心", "王志毅", "男", "14040219690430203X", "13503556999"});

        employeeList.add(new String[]{"太原业务中心", "宋刚", "男", "140104197206243715", "13613467780"});
        employeeList.add(new String[]{"安全监察部", "梁俊萍", "女", "140102197504234021", "15835129136"});
        employeeList.add(new String[]{"经营管理部", "曲媛", "女", "140102197601092344", "13834130260"});
        employeeList.add(new String[]{"太原业务中心", "罗宝生", "男", "140102197107221294", "13033480111"});

        employeeList.add(new String[]{"太原业务中心", "李佳钰", "女", "140106199005291843", "18636186378"});
        employeeList.add(new String[]{"太原业务中心", "韩  喆", "男", "14010619910326251X", "13453171857"});
        employeeList.add(new String[]{"太原业务中心", "杨  君", "男", "14012119911108063X", "18234015687"});
        employeeList.add(new String[]{"晋中业务中心", "贺志虎", "男", "140227198302104410", "15333662986"});
        employeeList.add(new String[]{"晋城业务中心", "张乐乐", "男", "140511198712147216", "15835620945"});
        employeeList.add(new String[]{"忻州业务中心", "赵金鹏", "男", "142201198709105536", "18636002772"});
        employeeList.add(new String[]{"临汾业务中心", "乔建", "男", "14260119901125443X", "15203571109"});
        employeeList.add(new String[]{"晋中业务中心", "段海鹰", "男", "142401198010095216", "13834182770"});
        employeeList.add(new String[]{"吕梁业务中心", "张伟锦", "男", "142326198410063514", "13546289541"});
        employeeList.add(new String[]{"吕梁业务中心", "乔晋伟", "男", "142302198209154237", "15534361902"});
        employeeList.add(new String[]{"太原业务中心", "谢立伟", "男", "14010719880916223X", "13620611590"});
        employeeList.add(new String[]{"太原业务中心", "戎文庭", "男", "142223197702146718", "18734588378"});
        employeeList.add(new String[]{"吕梁业务中心", "罗福兵", "男", "14230219840414005X", "18803582000"});
        employeeList.add(new String[]{"忻州业务中心", "赵兴朝", "男", "14220119880405903X", "13620607797"});
        employeeList.add(new String[]{"财务资产部", "史淑彦", "女", "142625198908040029", "15513462973"});
        employeeList.add(new String[]{"人力资源部", "胡静雯", "女", "140522198703190043", "15333006742"});
        employeeList.add(new String[]{"经营管理部", "闫乾峰", "男", "410181198302196915", "13485340445"});
        employeeList.add(new String[]{"安全监察部", "樊荣", "男", "140431198201050017", "18803552686"});
        employeeList.add(new String[]{"工程技术部", "郭华平", "男", "142636198605174416", "18035116684"});
        employeeList.add(new String[]{"工程技术部", "李俊", "男", "140109198809292571", "13007084092"});
        employeeList.add(new String[]{"经营管理部", "侯晓光", "男", "142431198911033651", "13834682896"});
        employeeList.add(new String[]{"经营管理部", "许世栋", "男", "140107198911283951", "15834112935"});
        employeeList.add(new String[]{"阳泉业务中心", "冯正斌", "男", "142730198808202517", "18903538481"});
        employeeList.add(new String[]{"运城业务中心", "王峰", "男", "142701198511042119", "13353599491"});
        employeeList.add(new String[]{"运城业务中心", "梁成", "男", "142701198806174813", "18935069983"});
        employeeList.add(new String[]{"综合管理部", "荆金星", "男", "142732198004071614", "18903434233"});
        employeeList.add(new String[]{"太原业务中心", "牛慧芸", "女", "140103197103160021", "13603569330"});
        employeeList.add(new String[]{"经营管理部", "赵坤", "女", "140411199608124849", "15803467626"});
        employeeList.add(new String[]{"人力资源部", "彭佳琪", "女", "140106199708221227", "13623513227"});
        employeeList.add(new String[]{"长治业务中心", "姜斐", "男", "140402198510292050", "13033460606"});
        employeeList.add(new String[]{"临汾业务中心", "金鑫", "男", "142601199006132614", "15303570613"});
        employeeList.add(new String[]{"晋中业务中心", "李乐波", "男", "140622199011093330", "15034698716"});
        employeeList.add(new String[]{"大同业务中心", "孟轶鑫", "男", "140202199111093517", "15110799518"});
        employeeList.add(new String[]{"安全监察部", "李宇明", "男", "142323198301041018", "13453443350"});
        employeeList.add(new String[]{"安全监察部", "袁捷", "男", "140109199006125838", "17735132623"});
        employeeList.add(new String[]{"财务资产部", "张子浩", "男", "140122198302110514", "15333667836"});
        employeeList.add(new String[]{"长治业务中心", "高翔", "男", "140424199503015250", "15034503011"});
        employeeList.add(new String[]{"运城业务中心", "陈卫社", "男", "142724197112141013", "18935097698"});
        employeeList.add(new String[]{"太原业务中心", "沈黛", "女", "140105198809120547", "17611288912"});
        employeeList.add(new String[]{"综合管理部", "程奇峰", "男", "140109199211121510", "15234109360"});
        employeeList.add(new String[]{"财务资产部", "白亭玉", "女", "140106200205110627", "18103466115"});

        employeeList.add(new String[]{"太原业务中心", "梁瑜", "女", "14010719940525006X", "15698328709"});
        employeeList.add(new String[]{"综合管理部", "梁  健", "男", "140102197608022314", "13333402318"});
        employeeList.add(new String[]{"党建部", "王小莹", "女", "142714199403073021", "13233599923"});
        employeeList.add(new String[]{"党建部", "白易鑫", "女", "140121199703188222", "15110363599"});
        employeeList.add(new String[]{"综合管理部", "邢乔惠", "女", "142402199706140020", "13700559115"});
        employeeList.add(new String[]{"党建部", "阎星如", "女", "140121200110062742", "18535162701"});
        employeeList.add(new String[]{"综合管理部", "王乙光", "男", "140106200303281219", "18234092000"});
        employeeList.add(new String[]{"综合管理部", "王舒萱", "女", "142401199903071443", "13513540668"});
        employeeList.add(new String[]{"人力资源部", "郑毅娇", "女", "140122199001182826", "13403400045"});
        employeeList.add(new String[]{"人力资源部", "王元春", "女", "140622198711010028", "13466811034"});
        employeeList.add(new String[]{"经营管理部", "安玲霞", "女", "140108198807242849", "13994205552"});
        employeeList.add(new String[]{"经营管理部", "黄馨瑶", "女", "140106199808241946", "15536983596"});
        employeeList.add(new String[]{"安全监察部", "张延培", "男", "140425198912150412", "18735560705"});
        employeeList.add(new String[]{"工程技术部", "郑丽君", "男", "142202198809220212", "15234777088"});
        employeeList.add(new String[]{"工程技术部", "周超瑜", "女", "140322199405207541", "13623539710"});
        employeeList.add(new String[]{"工程技术部", "任志坚", "男", "140105199108270010", "17735152678"});
        employeeList.add(new String[]{"综合管理部", "葛烜", "男", "140102197909221439", "13453416668"});
        employeeList.add(new String[]{"党建部", "宋梦蝶", "女", "140105199504010528", "18535133410"});
        employeeList.add(new String[]{"综合管理部", "郭朝玉", "女", "410521199708300524", "15213461392"});

        employeeList.add(new String[]{"大同业务中心", "赵党生", "男", "140202196507012038", "18903422422"});
        employeeList.add(new String[]{"大同业务中心", "聂鹏霞", "男", "140211197802280511", "15035221886"});
        employeeList.add(new String[]{"大同业务中心", "王卫东", "男", "140221198504190013", "13353424822"});
        employeeList.add(new String[]{"大同业务中心", "霍瑞东", "男", "140211196312052116", "13191283540"});
        employeeList.add(new String[]{"大同业务中心", "石雷", "男", "142701198210183612", "15035228898"});
        employeeList.add(new String[]{"大同业务中心", "钟嘉斌", "男", "140202198907144039", "15035660897"});
        employeeList.add(new String[]{"大同业务中心", "张秋野", "男", "230123198711070611", "15935267676"});
        employeeList.add(new String[]{"大同业务中心", "张俊鹏", "男", "14021119861114081X", "13663420188"});
        employeeList.add(new String[]{"大同业务中心", "石晓", "男", "142701198504223616", "18903428512"});
        employeeList.add(new String[]{"大同业务中心", "李晓辉", "男", "142701199212253615", "13509720612"});
        employeeList.add(new String[]{"大同业务中心", "张东", "男", "140202197610093539", "13934754218"});
        employeeList.add(new String[]{"大同业务中心", "郭建", "女", "140211199112083325", "15035268953"});
        employeeList.add(new String[]{"大同业务中心", "李世杰", "男", "140624199609285516", "17262444466"});
        employeeList.add(new String[]{"大同业务中心", "许占平", "男", "142132196901054118", "13934768869"});
        employeeList.add(new String[]{"大同业务中心", "支钰斌", "男", "140603199506040514", "18635237866"});
        employeeList.add(new String[]{"大同业务中心", "张冉", "男", "140202199407245532", "15835370760"});
        employeeList.add(new String[]{"大同业务中心", "王瀚卿", "男", "140202199712190013", "13835270641"});
        employeeList.add(new String[]{"大同业务中心", "刘宇", "男", "140202199002087038", "17635236687"});
        employeeList.add(new String[]{"大同业务中心", "刘刚", "男", "142124196102161814", "13835203472"});
        employeeList.add(new String[]{"大同业务中心", "李进喜", "男", "142123196111181511", "18635213997"});
        employeeList.add(new String[]{"大同业务中心", "王冬冬", "女", "140202196902203029", "13754926608"});
        employeeList.add(new String[]{"大同业务中心", "耿艳新", "男", "210922197011097214", "13934123532"});
        employeeList.add(new String[]{"大同业务中心", "范红梅", "女", "140202196705122609", "13994328915"});
        employeeList.add(new String[]{"大同业务中心", "刘振平", "女", "140202196203232023", "13096688716"});
        employeeList.add(new String[]{"大同业务中心", "张丽梅", "女", "14020219711203312X", "13934784601"});
        employeeList.add(new String[]{"大同业务中心", "张连喜", "男", "140202196201182018", "13934124220"});
        employeeList.add(new String[]{"大同业务中心", "张军", "男", "14213219721105473X", "13934754218"});
        employeeList.add(new String[]{"大同业务中心", "李莎", "女", "142623199004185227", "15103521439"});
        employeeList.add(new String[]{"大同业务中心", "刘根成", "男", "140211198009160818", "15635291137"});
        employeeList.add(new String[]{"大同业务中心", "杨忠", "男", "140202196402010036", "13703526359"});
        employeeList.add(new String[]{"大同业务中心", "顾梦思", "女", "140581199004160069", "18903528709"});
        employeeList.add(new String[]{"大同业务中心", "石安宁", "男", "140202196205222013", "13509720612"});
        employeeList.add(new String[]{"大同业务中心", "王潇冉", "女", "140212200104233946", "13353523598"});
        employeeList.add(new String[]{"大同业务中心", "杨志伟", "男", "140211198408204718", "15935242438"});
        employeeList.add(new String[]{"大同业务中心", "张文娟", "女", "140203199203070028", "13593015935"});
        employeeList.add(new String[]{"大同业务中心", "赵勇", "男", "140211199208051811", "13835204502"});
        employeeList.add(new String[]{"大同业务中心", "赵利军", "男", "140202198501152012", "13994455562"});
        employeeList.add(new String[]{"大同业务中心", "贾磊", "男", "140203199001207612", "13593030560"});
        employeeList.add(new String[]{"大同业务中心", "李建", "男", "140202196808070012", "13903526489"});
        employeeList.add(new String[]{"大同业务中心", "罗利梅", "女", "140202197306201021", "13503528392"});
        employeeList.add(new String[]{"大同业务中心", "范立华", "女", "140202197107172563", "13513665402"});
        employeeList.add(new String[]{"大同业务中心", "孙存太", "男", "142122196505130032", "18603521211"});
        employeeList.add(new String[]{"大同业务中心", "贾振国", "男", "140202199108042057", "13835278909"});
        employeeList.add(new String[]{"大同业务中心", "刘强", "男", "140202198409023015", "13633523555"});
        employeeList.add(new String[]{"大同业务中心", "田华", "男", "14021119731107051X", "13835218458"});
        employeeList.add(new String[]{"大同业务中心", "刘洋", "男", "140222198809056014", "18835219869"});
        employeeList.add(new String[]{"大同业务中心", "李生茂", "男", "140202196310083019", "15935269400"});
        employeeList.add(new String[]{"大同业务中心", "王鹏飞", "男", "140202199301186511", "15333624845"});
        employeeList.add(new String[]{"大同业务中心", "李雪峰", "女", "140602199601169029", "18406504516"});
        employeeList.add(new String[]{"大同业务中心", "李英", "男", "140223196407021035", "13734213777"});
        employeeList.add(new String[]{"大同业务中心", "郝培胜", "男", "142124196204192000", "13509787179"});
        employeeList.add(new String[]{"大同业务中心", "韩希恒", "男", "142123196503270011", "13994351086"});
        employeeList.add(new String[]{"大同业务中心", "李全", "男", "142133196905115000", "13994929313"});
        employeeList.add(new String[]{"大同业务中心", "张进", "男", "140202196408203000", "18903428052"});
        employeeList.add(new String[]{"大同业务中心", "张淇", "男", "140202200603092532", "18935225218"});


        employeeList.add(new String[]{"晋城业务中心", "邢天胜", "男", "140511196404230035", "15635650850"});
        employeeList.add(new String[]{"晋城业务中心", "张满忠", "男", "140524196305150058", "13834325088"});
        employeeList.add(new String[]{"晋城业务中心", "郭春锁", "男", "140581196302110031", "18835603828"});
        employeeList.add(new String[]{"晋城业务中心", "李颖", "女", "140502199205060026", "18435619196"});
        employeeList.add(new String[]{"晋城业务中心", "郭国社", "男", "140522196402096230", "13753647939"});
        employeeList.add(new String[]{"晋城业务中心", "李秀龙", "男", "140524196012130010", "13834325013"});
        employeeList.add(new String[]{"晋城业务中心", "栗羊保", "男", "140522196209182319", "13834310018"});
        employeeList.add(new String[]{"晋城业务中心", "杨杰", "男", "140522199406211535", "18535628785"});
        employeeList.add(new String[]{"晋城业务中心", "闫瑞林", "男", "140511196309216315", "18735601050"});
        employeeList.add(new String[]{"晋城业务中心", "魏珊姗", "女", "140525199811249341", "19834536697"});
        employeeList.add(new String[]{"晋城业务中心", "孙伟", "男", "140522199210010010", "13453633311"});
        employeeList.add(new String[]{"晋城业务中心", "张国强", "男", "140511198701022338", "18635611236"});
        employeeList.add(new String[]{"晋城业务中心", "魏莉莉", "女", "14052519860224382X", "13994717836"});
        employeeList.add(new String[]{"晋城业务中心", "毛立珍", "女", "142424198606073223", "15034601182"});
        employeeList.add(new String[]{"晋城业务中心", "张林杰", "男", "140402196403140431", "13503562199"});
        employeeList.add(new String[]{"晋城业务中心", "赵帅", "男", "14042199109207634", "15735662042"});
        employeeList.add(new String[]{"晋城业务中心", "陈森", "男", "14058119930908161X", "15386863538"});
        employeeList.add(new String[]{"晋城业务中心", "牛嘉浩", "男", "140581199410131116", "18535691009"});
        employeeList.add(new String[]{"晋城业务中心", "郭乐善", "男", "140522196306020033", "15803569812"});
        employeeList.add(new String[]{"晋城业务中心", "王永胜", "男", "140522196304061034", "13363565992"});
        employeeList.add(new String[]{"晋城业务中心", "刘国龙", "男", "140522196306013917", "15702683133"});
        employeeList.add(new String[]{"晋城业务中心", "芦自强", "男", "140502199606112210", "13637400380"});
        employeeList.add(new String[]{"晋城业务中心", "宋丁丁", "男", "140522199111030032", "13613561560"});
        employeeList.add(new String[]{"晋城业务中心", "姬守业", "男", "140522196112130031", "13934065180"});
        employeeList.add(new String[]{"晋城业务中心", "田瑞萍", "女", "140402196611242029", "13934319369"});
        employeeList.add(new String[]{"晋城业务中心", "史晋良", "男", "140521198106228633", "15135694387"});
        employeeList.add(new String[]{"晋城业务中心", "陈河柱", "男", "140511196311097239", "13835674046"});
        employeeList.add(new String[]{"晋城业务中心", "牛大庆", "男", "140581196309270011", "13097653880"});
        employeeList.add(new String[]{"晋城业务中心", "张保国", "男", "140581196311253915", "13935633005"});
        employeeList.add(new String[]{"晋城业务中心", "王容社", "男", "140522196304033017", "13834918056"});
        employeeList.add(new String[]{"晋城业务中心", "赵玉琪", "女", "140581199705264223", "18434364907"});
        employeeList.add(new String[]{"晋城业务中心", "程建会", "男", "140502196409223014", "13835642521"});
        employeeList.add(new String[]{"晋城业务中心", "张光忠", "男", "14050219640913103X", "13503569028"});
        employeeList.add(new String[]{"晋城业务中心", "李泽峰", "男", "140522199709190014", "13038059882"});
        employeeList.add(new String[]{"晋城业务中心", "张玉华", "女", "140502196906040024", "13834929999"});
        employeeList.add(new String[]{"晋城业务中心", "孙尚文", "男", "140522199706010014", "15536088650"});
        employeeList.add(new String[]{"晋城业务中心", "张育勤", "男", "140521196501118232", "13935688173"});


        employeeList.add(new String[]{"晋中业务中心", "辛华夏", "女", "142401199205081441", "18335470831"});
        employeeList.add(new String[]{"晋中业务中心", "李铣", "男", "142401196805202514", "18003548701"});
        employeeList.add(new String[]{"晋中业务中心", "辛晓红", "女", "14240119850503372X", "13633543017"});
        employeeList.add(new String[]{"晋中业务中心", "赵丽", "女", "140430198907132827", "18534615300"});
        employeeList.add(new String[]{"晋中业务中心", "张文生", "男", "142401196906191412", "18635079578"});
        employeeList.add(new String[]{"晋中业务中心", "郭伟", "男", "142430198606013113", "15903548172"});
        employeeList.add(new String[]{"晋中业务中心", "方御", "男", "142401198109110914", "18603549557"});
        employeeList.add(new String[]{"晋中业务中心", "谢颖", "女", "150403198701081529", "15035613665"});
        employeeList.add(new String[]{"晋中业务中心", "白曜华", "男", "142429199506241011", "13546631074"});
        employeeList.add(new String[]{"晋中业务中心", "弓红雨", "女", "142427199805195120", "13653540700"});
        employeeList.add(new String[]{"晋中业务中心", "董国君", "男", "142401198503181438", "15035612665"});
        employeeList.add(new String[]{"晋中业务中心", "陈富元", "男", "14242419630312651X", "18703543625"});
        employeeList.add(new String[]{"晋中业务中心", "郭伟业", "男", "140702200008117034", "19131296225"});
        employeeList.add(new String[]{"晋中业务中心", "孔鑫", "男", "142430198712240010", "15234401351"});
        employeeList.add(new String[]{"晋中业务中心", "赵亮", "男", "142423199011033618", "18635460192"});
        employeeList.add(new String[]{"晋中业务中心", "杨昕", "男", "140729198807220054", "13453223431"});
        employeeList.add(new String[]{"晋中业务中心", "马文廷", "男", "142401198704262410", "15535419998"});
        employeeList.add(new String[]{"晋中业务中心", "袁帆", "女", "142401199510311469", "15835463954"});
        employeeList.add(new String[]{"晋中业务中心", "王利明", "男", "142427198611196315", "15303442306"});
        employeeList.add(new String[]{"晋中业务中心", "刘建荣", "女", "14243019721030004X", "18703543419"});
        employeeList.add(new String[]{"晋中业务中心", "武建业", "男", "14240119601015183Ｘ", "13903443886"});
        employeeList.add(new String[]{"晋中业务中心", "曲日明", "男", "142401196108081411", "13935418882"});
        employeeList.add(new String[]{"晋中业务中心", "王志强", "男", "142401197107120612", "13593099159"});
        employeeList.add(new String[]{"晋中业务中心", "刘毅", "男", "140721199411220094", "18003441362"});
        employeeList.add(new String[]{"晋中业务中心", "李甲明", "男", "14240119620910183X", "13700558600"});
        employeeList.add(new String[]{"晋中业务中心", "王洋", "男", "14243319850930003X", "15110658789"});
        employeeList.add(new String[]{"晋中业务中心", "李文勇", "男", "142401198905226256", "19529108887"});
        employeeList.add(new String[]{"晋中业务中心", "解洪源", "男", "142431199009230057", "15935659002"});
        employeeList.add(new String[]{"晋中业务中心", "闫连柱", "男", "14240119710301621X", "15110676597"});
        employeeList.add(new String[]{"晋中业务中心", "范杰华", "男", "142430197910122715", "13513541113"});
        employeeList.add(new String[]{"晋中业务中心", "陈保平", "男", "142429197303186711", "13934410826"});
        employeeList.add(new String[]{"晋中业务中心", "刘卫华", "男", "142431197304260014", "13835489067"});
        employeeList.add(new String[]{"晋中业务中心", "高建春", "男", "14242219700214031X", "18503412799"});
        employeeList.add(new String[]{"晋中业务中心", "原再兴", "男", "142402196112280014", "13313549959"});
        employeeList.add(new String[]{"晋中业务中心", "张建俊", "男", "142429196306020018", "15235415188"});
        employeeList.add(new String[]{"晋中业务中心", "王栋", "男", "142401199307031410", "18635424480"});
        employeeList.add(new String[]{"晋中业务中心", "高永鹏", "男", "142401196211100318", "13835461385"});
        employeeList.add(new String[]{"晋中业务中心", "张瑞海", "男", "142401196401261817", "13623546790"});
        employeeList.add(new String[]{"晋中业务中心", "孙晓瑞", "男", "140622200202283917", "19935467422"});
        employeeList.add(new String[]{"晋中业务中心", "邵琛博", "男", "14272920030725361X", "18834498514"});
        employeeList.add(new String[]{"晋中业务中心", "雷森彭", "男", "142401199401071419", "15035641616"});
        employeeList.add(new String[]{"晋中业务中心", "赵清树", "男", "142431196912280030", "15333055281"});
        employeeList.add(new String[]{"晋中业务中心", "郭强", "男", "142429197008281011", "15035670777"});
        employeeList.add(new String[]{"晋中业务中心", "郝凤逵", "男", "142401197501082714", "13393547588"});
        employeeList.add(new String[]{"晋中业务中心", "李志凯", "男", "142402198512196013", "15003543678"});
        employeeList.add(new String[]{"晋中业务中心", "潘峰", "男", "142401198910150313", "18634261744"});
        employeeList.add(new String[]{"晋中业务中心", "郭振岳", "男", "142429199006103835", "13663441776"});
        employeeList.add(new String[]{"晋中业务中心", "刘云明", "男", "142422196211091513", "13834813310"});
        employeeList.add(new String[]{"晋中业务中心", "张文奇", "男", "140702199504037193", "18234496005"});
        employeeList.add(new String[]{"晋中业务中心", "王佳伟", "男", "140621200004217221", "18910327221"});
        employeeList.add(new String[]{"晋中业务中心", "贾诚志", "男", "142430199809210015", "13027050552"});
        employeeList.add(new String[]{"晋中业务中心", "严明", "男", "14240219640820001X", "18303447039"});

        employeeList.add(new String[]{"临汾业务中心", "柴红涛", "男", "142601196302181337", "13509770022"});
        employeeList.add(new String[]{"临汾业务中心", "成艳丽", "女", "142603197805137327", "13503578822"});
        employeeList.add(new String[]{"临汾业务中心", "靳剑", "男", "142630199003121014", "18735731116"});
        employeeList.add(new String[]{"临汾业务中心", "刘超", "男", "142601199509122610", "17835955959"});
        employeeList.add(new String[]{"临汾业务中心", "李永华", "男", "141002197612090059", "13753513285"});
        employeeList.add(new String[]{"临汾业务中心", "武昭君", "女", "142601199706241328", "13453666789"});
        employeeList.add(new String[]{"临汾业务中心", "冯恺欣", "女", "142625199710240425", "15535781997"});
        employeeList.add(new String[]{"临汾业务中心", "范世杰", "男", "142623198403150051", "18234783568"});
        employeeList.add(new String[]{"临汾业务中心", "张旺", "男", "142601198205022114", "13513573306"});
        employeeList.add(new String[]{"临汾业务中心", "成浩", "男", "142631198903247415", "15535768866"});
        employeeList.add(new String[]{"临汾业务中心", "房洁", "女", "142602198604301520", "13700577751"});
        employeeList.add(new String[]{"临汾业务中心", "冯学忠", "男", "142601196409244019", "13934172687"});
        employeeList.add(new String[]{"临汾业务中心", "王东红", "男", "142622196308020018", "13934072986"});
        employeeList.add(new String[]{"临汾业务中心", "燕蒲红", "男", "141033198003050018", "13593501605"});
        employeeList.add(new String[]{"临汾业务中心", "宋嘉钏", "男", "14100219900701003X", "13008034922"});
        employeeList.add(new String[]{"临汾业务中心", "耿熙晨", "男", "142625199304080016", "18735940124"});
        employeeList.add(new String[]{"临汾业务中心", "卫立雄", "男", "142623199310260053", "18435757133"});
        employeeList.add(new String[]{"临汾业务中心", "靳佳华", "男", "142601199609220130", "15935363627"});
        employeeList.add(new String[]{"临汾业务中心", "周旋", "男", "142623199408070055", "13935760529"});
        employeeList.add(new String[]{"临汾业务中心", "樊江", "男", "142601198911183417", "15386875111"});
        employeeList.add(new String[]{"临汾业务中心", "全隆", "男", "142601199306151331", "13513572178"});
        employeeList.add(new String[]{"临汾业务中心", "张振", "男", "142601199511252617", "18003573363"});
        employeeList.add(new String[]{"临汾业务中心", "刘云星", "男", "142601196405064037", "13924178610"});
        employeeList.add(new String[]{"临汾业务中心", "刘荣", "男", "142631197405140717", "17835963426"});
        employeeList.add(new String[]{"临汾业务中心", "段国明", "男", "1426011760109561X", "18434813845"});
        employeeList.add(new String[]{"临汾业务中心", "王迎龙", "男", "14260198802111019", "17535703833"});
        employeeList.add(new String[]{"临汾业务中心", "贾斌", "男", "142601198803122350", "17303575566"});
        employeeList.add(new String[]{"临汾业务中心", "高海峰", "男", "142625199809250017", "13100179885"});
        employeeList.add(new String[]{"临汾业务中心", "孙韶阳", "男", "142601199805112310", "13734077319"});
        employeeList.add(new String[]{"临汾业务中心", "王钏", "男", "14260198802271311", "13403474440"});
        employeeList.add(new String[]{"临汾业务中心", "李昊天", "男", "142601199608201314", "13935797922"});
        employeeList.add(new String[]{"临汾业务中心", "田雨", "男", "140222199001120014", "18603576554"});
        employeeList.add(new String[]{"临汾业务中心", "陈海洋", "男", "14260120000421139x", "15035744555"});
        employeeList.add(new String[]{"临汾业务中心", "郭璟云", "男", "142601199507011730", "15503614110"});
        employeeList.add(new String[]{"临汾业务中心", "李金洋", "男", "142601199405262854", "15934598989"});
        employeeList.add(new String[]{"临汾业务中心", "马健", "男", "142601199010282631", "15103479557"});
        employeeList.add(new String[]{"临汾业务中心", "齐昊", "男", "142601199603022130", "17636262999"});
        employeeList.add(new String[]{"临汾业务中心", "王娟", "女", "14260119800229286X", "13303478282"});
        employeeList.add(new String[]{"临汾业务中心", "谷跃明", "男", "142623196103010015", "13663570666"});
        employeeList.add(new String[]{"临汾业务中心", "王如录", "男", "142622196204010034", "13703571812"});
        employeeList.add(new String[]{"临汾业务中心", "张海生", "男", "142601196010208710", "15383572600"});
        employeeList.add(new String[]{"临汾业务中心", "席玉山", "男", "142629196211071016", "13935717929"});
        employeeList.add(new String[]{"临汾业务中心", "冯直平", "男", "142634197210259311", "13700574507"});
        employeeList.add(new String[]{"临汾业务中心", "燕航", "男", "141024199803050057", "13293871200"});
        employeeList.add(new String[]{"临汾业务中心", "王凯", "男", "142622198808220015", "15235729949"});
        employeeList.add(new String[]{"临汾业务中心", "崔秀生", "男", "141030196401190034", "13903476788"});
        employeeList.add(new String[]{"临汾业务中心", "谢建平", "男", "14263019631001301x", "13934341326"});
        employeeList.add(new String[]{"临汾业务中心", "石琪", "男", "142625199512010039", "18735740090"});
        employeeList.add(new String[]{"临汾业务中心", "周林", "男", "142623196303210054", "13934701518"});
        employeeList.add(new String[]{"临汾业务中心", "谭湘伟", "男", "142601199205071332", "19035715726"});
        employeeList.add(new String[]{"临汾业务中心", "史江涛", "男", "142627198610210032", "13191179059"});
        employeeList.add(new String[]{"临汾业务中心", "岳亚辉", "女", "141002200211060224", "18735775515"});
        employeeList.add(new String[]{"临汾业务中心", "孙永平", "男", "142632198311033014", "13293574555"});
        employeeList.add(new String[]{"临汾业务中心", "刘谦", "男", "141023199510170016", "15034384592"});
        employeeList.add(new String[]{"临汾业务中心", "裴泽龙", "男", "142622199803284719", "15034359521"});
        employeeList.add(new String[]{"临汾业务中心", "李浩明", "男", "142633199702151019", "19335746662"});

        employeeList.add(new String[]{"吕梁业务中心", "任建国", "男", "142331196011221011", "18903581015"});
        employeeList.add(new String[]{"吕梁业务中心", "张彩云", "女", "141102199005080208", "15235839393"});
        employeeList.add(new String[]{"吕梁业务中心", "徐杰", "男", "141182198805100059", "13803485445"});
        employeeList.add(new String[]{"吕梁业务中心", "辛国军", "男", "142302198809090097", "18635836729"});
        employeeList.add(new String[]{"吕梁业务中心", "李薇", "女", "141102198211200026", "13453897222"});
        employeeList.add(new String[]{"吕梁业务中心", "白治权", "男", "142302198512261094", "13935837778"});
        employeeList.add(new String[]{"吕梁业务中心", "张根德", "男", "142321197808130071", "13935806990"});
        employeeList.add(new String[]{"吕梁业务中心", "赵鹏", "男", "142303199310103654", "15110381407"});
        employeeList.add(new String[]{"吕梁业务中心", "刘新平", "男", "142326197104241218", "13453895000"});
        employeeList.add(new String[]{"吕梁业务中心", "杨志芳", "女", "142332198407210023", "18903581609"});
        employeeList.add(new String[]{"吕梁业务中心", "李嘉伦", "男", "141121199609030059", "18435166811"});
        employeeList.add(new String[]{"吕梁业务中心", "韩天阳", "男", "141121199801270052", "18235805833"});
        employeeList.add(new String[]{"吕梁业务中心", "闫占玺", "男", "141182199306270031", "17635887654"});
        employeeList.add(new String[]{"吕梁业务中心", "张剑", "男", "141182198909060039", "18735868286"});
        employeeList.add(new String[]{"吕梁业务中心", "杨焕", "男", "141182199701220018", "18403588538"});
        employeeList.add(new String[]{"吕梁业务中心", "陈国栋", "男", "14112219880202009X", "15135834445"});
        employeeList.add(new String[]{"吕梁业务中心", "高晖", "男", "142301197705050014", "15525758667"});
        employeeList.add(new String[]{"吕梁业务中心", "赵广前", "男", "14232219861022863X", "15935197077"});
        employeeList.add(new String[]{"吕梁业务中心", "张彩燕", "女", "141102199410220067", "13835847494"});
        employeeList.add(new String[]{"吕梁业务中心", "赵煜坤", "男", "142703199907162114", "18434934012"});
        employeeList.add(new String[]{"吕梁业务中心", "闫诗文", "女", "141102199912090020", "17867285654"});
        employeeList.add(new String[]{"吕梁业务中心", "武承昊", "男", "141122200210080099", "13834361828"});
        employeeList.add(new String[]{"吕梁业务中心", "何磊", "男", "142331199907010018", "15535859580"});
        employeeList.add(new String[]{"吕梁业务中心", "任建新", "男", "142332196411290012", "13934018992"});
        employeeList.add(new String[]{"吕梁业务中心", "李敦宁", "男", "14112197401310051", "15534393444"});
        employeeList.add(new String[]{"吕梁业务中心", "郝广文", "男", "142322196411056012", "18035812147"});
        employeeList.add(new String[]{"吕梁业务中心", "曹逸凡", "男", "142302199907280016", "18903586859"});
        employeeList.add(new String[]{"吕梁业务中心", "何梓渊", "男", "142302199307030056", "18966836591"});

        employeeList.add(new String[]{"朔州业务中心", "尚有为", "男", "140622196510260013", "18903498699"});
        employeeList.add(new String[]{"朔州业务中心", "李卫宇", "男", "140602198604309010", "18903498838"});
        employeeList.add(new String[]{"朔州业务中心", "尚晓东", "男", "142133197610020517", "18903498921"});
        employeeList.add(new String[]{"朔州业务中心", "李俊伟", "男", "140602199109309018", "18903498923"});
        employeeList.add(new String[]{"朔州业务中心", "杜晋杰", "男", "140621197711183015", "13513697843"});
        employeeList.add(new String[]{"朔州业务中心", "施子强", "男", "140622199005030819", "13383499756"});
        employeeList.add(new String[]{"朔州业务中心", "马永", "男", "142133197810263011", "13152716725"});
        employeeList.add(new String[]{"朔州业务中心", "马建成", "男", "140624197511253015", "13834427514"});
        employeeList.add(new String[]{"朔州业务中心", "吉余喜", "男", "142624197408233016", "13593464480"});
        employeeList.add(new String[]{"朔州业务中心", "高泽民", "男", "140603198902224919", "18903498922"});
        employeeList.add(new String[]{"朔州业务中心", "赵晋文", "男", "140602198812272013", "15803473122"});
        employeeList.add(new String[]{"朔州业务中心", "李惠娟", "女", "140621198712100045", "18903498856"});
        employeeList.add(new String[]{"朔州业务中心", "孙晨军", "男", "140622198402070019", "13934839106"});
        employeeList.add(new String[]{"朔州业务中心", "张文军", "男", "140602197901098518", "13934992119"});
        employeeList.add(new String[]{"朔州业务中心", "刘利军", "男", "140603199102100517", "13834992038"});
        employeeList.add(new String[]{"朔州业务中心", "张帅", "男", "140602198902019011", "18903492908"});
        employeeList.add(new String[]{"朔州业务中心", "安保成", "男", "140203197705041615", "13152714245"});
        employeeList.add(new String[]{"朔州业务中心", "王鹏", "男", "140602198401042512", "13333490871"});
        employeeList.add(new String[]{"朔州业务中心", "宣祥", "男", "140602198902080517", "18534936331"});
        employeeList.add(new String[]{"朔州业务中心", "周海霞", "女", "142230198610091340", "13994921693"});
        employeeList.add(new String[]{"朔州业务中心", "杜文全", "男", "142128196409102013", "13994933589"});
        employeeList.add(new String[]{"朔州业务中心", "陈志强", "男", "142131196902113013", "13834420621"});
        employeeList.add(new String[]{"朔州业务中心", "何鑫高格", "男", "140602200002131710", "13044436669"});
        employeeList.add(new String[]{"朔州业务中心", "刘国翔", "男", "140602199903291513", "15296698815"});
        employeeList.add(new String[]{"朔州业务中心", "赵敏", "男", "140603196212080533", "18903498575"});
        employeeList.add(new String[]{"朔州业务中心", "卢文", "男", "142128197010164014", "18903492262"});
        employeeList.add(new String[]{"朔州业务中心", "丁志", "男", "14060319940106101X", "18334923166"});
        employeeList.add(new String[]{"朔州业务中心", "秦素文", "男", "140622198809231611", "18603492559"});
        employeeList.add(new String[]{"朔州业务中心", "李宇东", "男", "140602199109200012", "18734941678"});
        employeeList.add(new String[]{"朔州业务中心", "王凯鹏", "男", "140602199901084510", "19194150218"});
        employeeList.add(new String[]{"朔州业务中心", "王鹏飞", "男", "140602199909291733", "18634995882"});
        employeeList.add(new String[]{"朔州业务中心", "孟志平", "男", "14213319630810001X", "18903498186"});
        employeeList.add(new String[]{"朔州业务中心", "闫致臻", "男", "140621199501110010", "18636288701"});

        employeeList.add(new String[]{"太原业务中心", "刘京泰", "男", "142201199105181452", "15135174548"});
        employeeList.add(new String[]{"太原业务中心", "李璐", "女", "140106198901230024", "13834654321"});
        employeeList.add(new String[]{"太原业务中心", "王怿", "男", "140106198810110617", "15834109812"});
        employeeList.add(new String[]{"太原业务中心", "苏鑫", "男", "140107199205112615", "13803412015"});
        employeeList.add(new String[]{"太原业务中心", "杨虹", "女", "140105199401080021", "15513038799"});
        employeeList.add(new String[]{"太原业务中心", "段艳", "女", "140103198111221546", "15935133545"});
        employeeList.add(new String[]{"太原业务中心", "柳宇", "男", "14230219910529001X", "15203583888"});
        employeeList.add(new String[]{"太原业务中心", "吕航", "男", "140107199301182613", "13027076752"});
        employeeList.add(new String[]{"太原业务中心", "刘艺鸿", "女", "142301199708190281", "17636629446"});
        employeeList.add(new String[]{"太原业务中心", "李平", "男", "140121199305257237", "18435121614"});
        employeeList.add(new String[]{"太原业务中心", "邓雪钦", "男", "140225199704220037", "15333660779"});
        employeeList.add(new String[]{"太原业务中心", "王霄鹏", "男", "140107199710111234", "15536883737"});
        employeeList.add(new String[]{"太原业务中心", "张励烽", "男", "140822199303260074", "15333663558"});
        employeeList.add(new String[]{"太原业务中心", "安如山", "男", "140110199208300011", "18135156520"});
        employeeList.add(new String[]{"太原业务中心", "赵杰", "男", "140430199405082836", "15536505783"});
        employeeList.add(new String[]{"太原业务中心", "韩静静", "女", "410928198906211284", "15035142310"});
        employeeList.add(new String[]{"太原业务中心", "胡一丁", "男", "140108199302102511", "13623632450"});
        employeeList.add(new String[]{"太原业务中心", "乔安帮", "男", "610202199608231252", "18391593730"});
        employeeList.add(new String[]{"太原业务中心", "康婷婷", "女", "140107198902281241", "18235109628"});
        employeeList.add(new String[]{"太原业务中心", "牛鑫宝", "男", "140121199410070618", "13353435336"});
        employeeList.add(new String[]{"太原业务中心", "殷健", "男", "140106199511091000", "18536892250"});
        employeeList.add(new String[]{"太原业务中心", "周浩", "男", "140106198703180011", "13754867350"});
        employeeList.add(new String[]{"太原业务中心", "李涛", "男", "14043119950607361X", "18103439030"});
        employeeList.add(new String[]{"太原业务中心", "马巍", "男", "140106199708102535", "15903469537"});
        employeeList.add(new String[]{"太原业务中心", "封杰", "男", "140103197012261513", "13466806969"});
        employeeList.add(new String[]{"太原业务中心", "王嘉栋", "男", "140105199604160013", "13700517201"});
        employeeList.add(new String[]{"太原业务中心", "王恒茂", "男", "140102196312303294", "13934600291"});
        employeeList.add(new String[]{"太原业务中心", "张智奇", "男", "140103198001210010", "18903517569"});
        employeeList.add(new String[]{"太原业务中心", "王佳威", "男", "140181199010164734", "15834065272"});
        employeeList.add(new String[]{"太原业务中心", "姚俭宝", "男", "14010319620307007X", "13703583728"});
        employeeList.add(new String[]{"太原业务中心", "崔勇平", "男", "140103196201090659", "13099003047"});
        employeeList.add(new String[]{"太原业务中心", "秦小荣", "男", "140104197409070850", "18135180995"});
        employeeList.add(new String[]{"太原业务中心", "牟晋生", "男", "140102196309246516", "13934600143"});
        employeeList.add(new String[]{"太原业务中心", "成爱萍", "女", "140102196809232049", "18636127635"});
        employeeList.add(new String[]{"太原业务中心", "宁喜增", "男", "140103196603165772", "13603566344"});
        employeeList.add(new String[]{"太原业务中心", "郭文斌", "男", "141127199005080192", "18234051440"});
        employeeList.add(new String[]{"太原业务中心", "李文斌", "男", "140123199310080213", "15834057440"});
        employeeList.add(new String[]{"太原业务中心", "郝香文", "男", "140102196501051233", "15303417671"});
        employeeList.add(new String[]{"太原业务中心", "王静怡", "女", "140107199604130626", "19935372405"});
        employeeList.add(new String[]{"太原业务中心", "康正源", "男", "142601198605173712", "13393519800"});
        employeeList.add(new String[]{"太原业务中心", "常富顺", "男", "140102196501284053", "13700501131"});
        employeeList.add(new String[]{"太原业务中心", "杜金虎", "男", "140112196104192414", "18135186031"});
        employeeList.add(new String[]{"太原业务中心", "吕四贵", "男", "140123196105147032", "13934542793"});
        employeeList.add(new String[]{"太原业务中心", "成玚", "女", "140108199603111921", "15103415851"});
        employeeList.add(new String[]{"太原业务中心", "姚文婷", "女", "141121199507200109", "13016909838"});
        employeeList.add(new String[]{"太原业务中心", "李磊", "男", "142725199005060432", "13233515511"});
        employeeList.add(new String[]{"太原业务中心", "王嘉鑫", "男", "140602199705029012", "15333668413"});
        employeeList.add(new String[]{"太原业务中心", "孙慧敏", "女", "140603199512170526", "17735102939"});
        employeeList.add(new String[]{"太原业务中心", "侯俊宝", "男", "140122199811180814", "17696059214"});
        employeeList.add(new String[]{"太原业务中心", "文飞", "男", "14022719841003005x", "15333660056"});
        employeeList.add(new String[]{"太原业务中心", "石健俊", "男", "140106199403141212", "18734909178"});
        employeeList.add(new String[]{"太原业务中心", "李欣洲", "男", "142322200106203513", "17582806749"});
        employeeList.add(new String[]{"太原业务中心", "钱睿星", "男", "140109199511270518", "15135187151"});
        employeeList.add(new String[]{"太原业务中心", "张晨昊", "男", "14010519970226051x", "18536803321"});
        employeeList.add(new String[]{"太原业务中心", "王志明", "男", "142301198411140537", "13834115665"});
        employeeList.add(new String[]{"太原业务中心", "张俊山", "男", "142228196203246359", "15903437833"});
        employeeList.add(new String[]{"太原业务中心", "周蓬勃", "男", "140122199807122814", "15513518512"});
        employeeList.add(new String[]{"太原业务中心", "卫泽鹏", "男", "142726198706241238", "17835186168"});
        employeeList.add(new String[]{"太原业务中心", "张青", "男", "140102196411164015", "13099057223"});
        employeeList.add(new String[]{"太原业务中心", "吕飞", "男", "14012319890525023X", "15536894279"});
        employeeList.add(new String[]{"太原业务中心", "李慧丰", "男", "142326199804011412", "13370117401"});
        employeeList.add(new String[]{"太原业务中心", "王晓东", "男", "140103196506295735", "18636125509"});
        employeeList.add(new String[]{"太原业务中心", "刘冬生", "男", "14010219601228321X", "13803466161"});

        employeeList.add(new String[]{"忻州业务中心", "许北安", "男", "142201196304130734", "13935060938"});
        employeeList.add(new String[]{"忻州业务中心", "冯少云", "女", "142201198806013801", "18295802359"});
        employeeList.add(new String[]{"忻州业务中心", "武一宁", "男", "142201198812239030", "18835039876"});
        employeeList.add(new String[]{"忻州业务中心", "寇勇伟", "男", "142201198311094291", "13835018022"});
        employeeList.add(new String[]{"忻州业务中心", "高杰", "男", "142201199212190733", "13485392959"});
        employeeList.add(new String[]{"忻州业务中心", "张成杰", "男", "142201199108203071", "15203506858"});
        employeeList.add(new String[]{"忻州业务中心", "贾小芳", "女", "142201199204015265", "18734356213"});
        employeeList.add(new String[]{"忻州业务中心", "王午云", "男", "142201198610189178", "13803440206"});
        employeeList.add(new String[]{"忻州业务中心", "杜俊东", "男", "142201198104102455", "13546607328"});
        employeeList.add(new String[]{"忻州业务中心", "马晓龙", "男", "142201198812180032", "18035016388"});
        employeeList.add(new String[]{"忻州业务中心", "赵书荣", "男", "142201198108165971", "13546709130"});
        employeeList.add(new String[]{"忻州业务中心", "于丽娟", "女", "142227198007160825", "18035000998"});
        employeeList.add(new String[]{"忻州业务中心", "曲志斌", "男", "142201197810259172", "13903502825"});
        employeeList.add(new String[]{"忻州业务中心", "杨建荣", "男", "142201197210051458", "15903503182"});
        employeeList.add(new String[]{"忻州业务中心", "牛青云", "男", "142201199602159192", "15513501328"});
        employeeList.add(new String[]{"忻州业务中心", "邢春泉", "男", "14220119750620111X", "13303505960"});
        employeeList.add(new String[]{"忻州业务中心", "王俊融", "女", "142201199104200746", "18834001688"});
        employeeList.add(new String[]{"忻州业务中心", "樊光余", "男", "142202199308101631", "18255132449"});
        employeeList.add(new String[]{"忻州业务中心", "谢江华", "女", "142201199607150744", "15383546905"});
        employeeList.add(new String[]{"忻州业务中心", "张树青", "女", "140902197009120020", "13453005040"});
        employeeList.add(new String[]{"忻州业务中心", "贺闻欣", "男", "142201199502129017", "18634659128"});
        employeeList.add(new String[]{"忻州业务中心", "张斌", "男", "142223199504097010", "18535080003"});
        employeeList.add(new String[]{"忻州业务中心", "宁一鑫", "男", "142201199404026217", "19233505967"});
        employeeList.add(new String[]{"忻州业务中心", "石琬云", "女", "142201200004070767", "15525668004"});
        employeeList.add(new String[]{"忻州业务中心", "贾二帅", "男", "142201199706049174", "18710702097"});
        employeeList.add(new String[]{"忻州业务中心", "李时同", "男", "142201199507070739", "17262462207"});
        employeeList.add(new String[]{"忻州业务中心", "郭媛", "女", "142201199009030742", "18335017646"});
        employeeList.add(new String[]{"忻州业务中心", "侯文林", "男", "142201196904063790", "13593204419"});
        employeeList.add(new String[]{"忻州业务中心", "张建钢", "男", "142201197908020012", "13935032071"});
        employeeList.add(new String[]{"忻州业务中心", "刘磊", "男", "142201200208232713", "15834276182"});
        employeeList.add(new String[]{"忻州业务中心", "杨文生", "男", "142231196111020019", "13834007636"});
        employeeList.add(new String[]{"忻州业务中心", "靳胜利", "男", "142234196111122233", "13994118453"});
        employeeList.add(new String[]{"忻州业务中心", "杜福音", "男", "142223196304056712", "13994173521"});
        employeeList.add(new String[]{"忻州业务中心", "郭伟", "男", "14222319720501241x", "13935036606"});
        employeeList.add(new String[]{"忻州业务中心", "张九九", "男", "140924196310080017", "13835057319"});
        employeeList.add(new String[]{"忻州业务中心", "张鸿儒", "男", "140602198908068519", "17803467510"});
        employeeList.add(new String[]{"忻州业务中心", "陈浩", "男", "142201199302230014", "13613504056"});
        employeeList.add(new String[]{"忻州业务中心", "米糈粒", "男", "142201199508039055", "17703501686"});
        employeeList.add(new String[]{"忻州业务中心", "柴一山", "男", "142201199803030731", "18335036668"});
        employeeList.add(new String[]{"忻州业务中心", "曹恒璋", "男", "142201200206153798", "13393501302"});
        employeeList.add(new String[]{"忻州业务中心", "刘斌", "男", "142230199211200014", "18635047937"});
        employeeList.add(new String[]{"忻州业务中心", "韩天礼", "男", "14222919770114003X", "13834006318"});
        employeeList.add(new String[]{"忻州业务中心", "闫亮清", "男", "142228197007086890", "15934305985"});
        employeeList.add(new String[]{"忻州业务中心", "冯帆", "女", "142234199105082224", "18636213843"});
        employeeList.add(new String[]{"忻州业务中心", "张晋恺", "男", "140902200409240077", "13293616889"});
        employeeList.add(new String[]{"忻州业务中心", "高昕", "男", "142226200211057415", "13935020547"});
        employeeList.add(new String[]{"忻州业务中心", "王金柱", "男", "142225197501200530", "13935083635"});
        employeeList.add(new String[]{"忻州业务中心", "常凯", "男", "142227199808131017", "16656107222"});
        employeeList.add(new String[]{"忻州业务中心", "周建全", "男", "14220119720823903X", "13934431776"});
        employeeList.add(new String[]{"忻州业务中心", "张宝成", "男", "142225196310060518", "13593226504"});
        employeeList.add(new String[]{"忻州业务中心", "杨艳华", "女", "142223196807056124", "15110534503"});
        employeeList.add(new String[]{"忻州业务中心", "高旭光", "男", "142201196410040732", "13835018915"});
        employeeList.add(new String[]{"忻州业务中心", "邢路旭", "男", "142223199701280914", "18835050395"});
        employeeList.add(new String[]{"忻州业务中心", "张博", "男", "142201200008299016", "18535017111"});
        employeeList.add(new String[]{"忻州业务中心", "李刚", "男", "142201196403050019", "18635036050"});


        employeeList.add(new String[]{"阳泉业务中心", "石雅莉", "女", "140302197512271368", "18903536144"});
        employeeList.add(new String[]{"阳泉业务中心", "宋超", "男", "140302198604040019", "18903539613"});
        employeeList.add(new String[]{"阳泉业务中心", "冯旭", "男", "140311198708150913", "15386737772"});
        employeeList.add(new String[]{"阳泉业务中心", "王升", "男", "14032119890401003X", "18903530164"});
        employeeList.add(new String[]{"阳泉业务中心", "郭智海", "男", "14030219950426161X", "18903536604"});
        employeeList.add(new String[]{"阳泉业务中心", "孙望杰", "男", "140721199705100055", "19935341750"});
        employeeList.add(new String[]{"阳泉业务中心", "于洋", "男", "140321198908094816", "18903536272"});
        employeeList.add(new String[]{"阳泉业务中心", "赵楠", "女", "140302198911040828", "18903532076"});
        employeeList.add(new String[]{"阳泉业务中心", "李业杰", "男", "140303199009072017", "18903536880"});
        employeeList.add(new String[]{"阳泉业务中心", "刘鑫", "男", "140302199008120818", "18903536547"});
        employeeList.add(new String[]{"阳泉业务中心", "闫雅蓉", "女", "140311199403130924", "18903533624"});
        employeeList.add(new String[]{"阳泉业务中心", "赵钰虎", "男", "140302199804232810", "18903534301"});
        employeeList.add(new String[]{"阳泉业务中心", "吴昊", "男", "140302200107101212", "18903536480"});
        employeeList.add(new String[]{"阳泉业务中心", "李潇剑", "男", "140302199604160410", "18903531643"});
        employeeList.add(new String[]{"阳泉业务中心", "雷嘉欣", "男", "140303199406030419", "18903538435"});
        employeeList.add(new String[]{"阳泉业务中心", "王冠鹏", "男", "140302199010200817", "18903530454"});
        employeeList.add(new String[]{"阳泉业务中心", "李小娟", "女", "142322198703210025", "18903536428"});
        employeeList.add(new String[]{"阳泉业务中心", "李柯宇", "男", "140303199701300039", "18903533986"});
        employeeList.add(new String[]{"阳泉业务中心", "王翔", "男", "140303199212070017", "18903532231"});
        employeeList.add(new String[]{"阳泉业务中心", "马慧文", "女", "140322199108027544", "13453339794"});
        employeeList.add(new String[]{"阳泉业务中心", "王涛峰", "男", "140311199605120919", "18903530104"});
        employeeList.add(new String[]{"阳泉业务中心", "王佳佳", "女", "140322198702187562", "13133232582"});
        employeeList.add(new String[]{"阳泉业务中心", "苗晓杰", "男", "140311199410260911", "18335332224"});
        employeeList.add(new String[]{"阳泉业务中心", "冯宇轩", "男", "140302199402260018", "18635365980"});
        employeeList.add(new String[]{"阳泉业务中心", "闫建章", "男", "140302196308310011", "18903532913"});
        employeeList.add(new String[]{"阳泉业务中心", "张怀文", "男", "140303196201111238", "18903532335"});
        employeeList.add(new String[]{"阳泉业务中心", "王先拴", "男", "140311196301132116", "13934032303"});
        employeeList.add(new String[]{"阳泉业务中心", "张艳云", "女", "14232219730731862X", "18917801395"});
        employeeList.add(new String[]{"阳泉业务中心", "任凤英", "女", "140303197309030821", "13935353068"});
        employeeList.add(new String[]{"阳泉业务中心", "武俊双", "男", "140322196011073313", "13834039491"});
        employeeList.add(new String[]{"阳泉业务中心", "李守国", "男", "140302196409080956", "18903532316"});



        employeeList.add(new String[]{"运城业务中心", "程宇玉", "男", "142731198802160332", "17634038880"});
        employeeList.add(new String[]{"运城业务中心", "杜瑞泽", "男", "142730199702040016", "19103595900"});
        employeeList.add(new String[]{"运城业务中心", "耿正帅", "男", "142726199307230018", "17735971212"});
        employeeList.add(new String[]{"运城业务中心", "李孟飞", "男", "142701198909257558", "15935902877"});
        employeeList.add(new String[]{"运城业务中心", "李宁", "男", "142732199108160413", "13753920378"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "马泽翔", "男", "142730199102180015", "18035988972"});
        employeeList.add(new String[]{"运城业务中心", "宁浴娟", "女", "142727199001141043", "15386728786"});
        employeeList.add(new String[]{"运城业务中心", "田定胜", "男", "14270119700305483X", "13513598025"});
        employeeList.add(new String[]{"运城业务中心", "王磊", "男", "14272919910716211X", "19135907899"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "张嵩", "男", "142701198906104812", "15535919495"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "卫世衡", "男", "142701199204231213", "18035966096"});
        employeeList.add(new String[]{"运城业务中心", "刘心灏", "男", "142732199308090034", "15235932667"});
        employeeList.add(new String[]{"运城业务中心", "赵泽", "男", "142701199009092131", "19335976885"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "王茹悦", "女", "142725199304284022", "18935063675"});
        employeeList.add(new String[]{"运城业务中心", "张倍嘉", "男", "142724199406164113", "17634002095"});
        employeeList.add(new String[]{"运城业务中心", "于海龙", "男", "142701196112291231", "18935079347"});
        employeeList.add(new String[]{"运城业务中心", "武万喜", "男", "142703196201242717", "18735907348"});
        employeeList.add(new String[]{"运城业务中心", "潘永红", "男", "612124196810172998", "18935099763"});
        employeeList.add(new String[]{"运城业务中心", "关怡轩", "男", "142701199803180614", "18295905755"});
        employeeList.add(new String[]{"运城业务中心", "尉中星", "男", "142725199203044812", "13028015255"});
        employeeList.add(new String[]{"运城业务中心", "屈新宇", "男", "142733199511295410", "13753949977"});
        employeeList.add(new String[]{"运城业务中心", "张武孝", "男", "142701196701255714", "15135928620"});
        employeeList.add(new String[]{"运城业务中心", "王彦森", "男", "142732196603156434", "13994872501"});
        employeeList.add(new String[]{"运城业务中心", "范翔宇", "男", "142725199202195213", "15296764566"});
        employeeList.add(new String[]{"运城业务中心", "王榕", "女", "142724200109091443", "13513592248"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "刘亚辉", "男", "142723199509300839", "18035464951"});
        employeeList.add(new String[]{"运城业务中心", "郭卫杰", "男", "142730199905230012", "15634986805"});
        employeeList.add(new String[]{"运城业务中心", "柴一凡", "男", "142732199606231616", "13641476454"});
        employeeList.add(new String[]{"运城业务中心", "霍晓祥", "男", "14272419970507023X", "15364896489"});
        employeeList.add(new String[]{"运城业务中心", "马伟新", "男", "142701196302011210", "18935071097"});
        employeeList.add(new String[]{"运城业务中心", "文学乐", "男", "14270219691228241X", "13994865403"});
        employeeList.add(new String[]{"运城业务中心", "樊敬顺", "男", "142703196502023075", "13994950916"});
        employeeList.add(new String[]{"运城业务中心", "闫柱良", "男", "142726196011121812", "13935996078"});
        employeeList.add(new String[]{"运城业务中心", "霍俊杰", "男", "142724197105230018", "18635906077"});
        employeeList.add(new String[]{"运城业务中心", "高枫林", "男", "142730196207180018", "18935071026"});
        employeeList.add(new String[]{"运城业务中心", "刘江锁", "男", "142732196503246416", "18935072379"});
        employeeList.add(new String[]{"运城业务中心", "李世民", "男", "142723196209302310", "13835956366"});
        employeeList.add(new String[]{"运城业务中心", "董立平", "男", "142723196308010858", "13835995202"});
        employeeList.add(new String[]{"运城业务中心", "张蔚", "男", "142729196010090013", "18935067283"}); // 去除姓名空格
        employeeList.add(new String[]{"运城业务中心", "王文博", "男", "142733196301310017", "18935076004"});
        employeeList.add(new String[]{"运城业务中心", "黄社拴", "男", "142731196107020312", "18935075185"});
        employeeList.add(new String[]{"运城业务中心", "裴黎明", "男", "142701196706046313", "13994966668"});
        employeeList.add(new String[]{"运城业务中心", "宋孟林", "男", "142727196407220354", "18935070158"});
        employeeList.add(new String[]{"运城业务中心", "邓博韬", "男", "142729199002116010", "18735921608"});
        employeeList.add(new String[]{"运城业务中心", "薛晋玉", "男", "142727196407160339", "18935070305"});
        employeeList.add(new String[]{"运城业务中心", "李青山", "男", "14272919630306541X", "18935067809"});
        employeeList.add(new String[]{"运城业务中心", "沈永龙", "男", "142724197401021616", "13546598319"});
        employeeList.add(new String[]{"运城业务中心", "武建敏", "男", "142725196309090418", "13835986698"});
        employeeList.add(new String[]{"运城业务中心", "宋文囤", "男", "142730196205111510", "13603594130"});
        employeeList.add(new String[]{"运城业务中心", "李点灶", "男", "142730196305070314", "18935071178"});
        employeeList.add(new String[]{"运城业务中心", "荆立冬", "男", "142724196611173912", "18935091556"});
        employeeList.add(new String[]{"运城业务中心", "张跃文", "男", "142701196206150632", "18935068566"});
        employeeList.add(new String[]{"运城业务中心", "张晓华", "男", "14270119630905183X", "18935079056"});
        employeeList.add(new String[]{"运城业务中心", "梁晓东", "男", "142702196412130014", "18935062298"});
        employeeList.add(new String[]{"运城业务中心", "陈新合", "男", "142730196301010613", "18935071088"});
        employeeList.add(new String[]{"运城业务中心", "薛清彦", "男", "142701196401274219", "13834955217"});
        employeeList.add(new String[]{"运城业务中心", "曹建民", "男", "142703196308150636", "13620696788"});
        employeeList.add(new String[]{"运城业务中心", "刘晓林", "男", "142701198801085432", "17735907236"});
        employeeList.add(new String[]{"运城业务中心", "张定海", "男", "142731196506044813", "18035912636"});
        employeeList.add(new String[]{"运城业务中心", "范新义", "男", "142726196601310015", "18935091385"});


        employeeList.add(new String[]{"长治业务中心", "佟超军", "男", "140429197503055634", "13835546667"});
        employeeList.add(new String[]{"长治业务中心", "武元皓", "男", "140402199606081631", "15034504459"});
        employeeList.add(new String[]{"长治业务中心", "张慧超", "女", "14043019900721002X", "18335605281"});
        employeeList.add(new String[]{"长治业务中心", "李腾英", "女", "140402200003062824", "15613418676"});
        employeeList.add(new String[]{"长治业务中心", "宇文翘楚", "男", "140402198510292050", "18953242731"});
        employeeList.add(new String[]{"长治业务中心", "申潞潞", "女", "140426200107163225", "18612835716"});
        employeeList.add(new String[]{"长治业务中心", "马源", "男", "140411199611144816", "15201560020"});
        employeeList.add(new String[]{"长治业务中心", "屈瑞华", "男", "140402198710212457", "15135506288"});
        employeeList.add(new String[]{"长治业务中心", "李晓凯", "男", "140421198503180017", "15603456463"});
        employeeList.add(new String[]{"长治业务中心", "姬腾飞", "男", "14040219890214281X", "13994694418"});
        employeeList.add(new String[]{"长治业务中心", "吕子健", "男", "140421200006193212", "17635534341"});
        employeeList.add(new String[]{"长治业务中心", "朱佑国", "男", "140402199508061610", "15534159191"});
        employeeList.add(new String[]{"长治业务中心", "刘向东", "男", "140426199501010416", "18703559231"});
        employeeList.add(new String[]{"长治业务中心", "陈佳琛", "男", "14040219970505281X", "13546654648"});
        employeeList.add(new String[]{"长治业务中心", "宇文浩", "男", "140426199105171218", "18834158034"});
        employeeList.add(new String[]{"长治业务中心", "李晓风", "男", "14042719831008641X", "18636555543"});
        employeeList.add(new String[]{"长治业务中心", "申慧伟", "男", "140426200004220012", "18636523601"});
        employeeList.add(new String[]{"长治业务中心", "康建利", "男", "140426196104254413", "15536114402"});
        employeeList.add(new String[]{"长治业务中心", "牛志超", "男", "140411200006284816", "18535533583"});
        employeeList.add(new String[]{"长治业务中心", "常雷雨", "男", "140426199011020013", "13028066130"});
        employeeList.add(new String[]{"长治业务中心", "宇文鹏云", "男", "140426197607201211", "15823576682"});
        employeeList.add(new String[]{"长治业务中心", "陈豆豆", "男", "140427199009138131", "13623552711"});
        employeeList.add(new String[]{"长治业务中心", "暴雪", "女", "140402199803302827", "19834420249"});
        employeeList.add(new String[]{"长治业务中心", "马睿哲", "男", "140402199909232011", "15934051199"});
        employeeList.add(new String[]{"长治业务中心", "申红斌", "男", "140402196509170030", "13467019110"});
        employeeList.add(new String[]{"长治业务中心", "王红宇", "男", "140428197509010019", "13593281361"});
        employeeList.add(new String[]{"长治业务中心", "岳军", "男", "140402197804142010", "13453520558"});
        employeeList.add(new String[]{"长治业务中心", "罗义红", "男", "14042819690420007X", "13333558623"}); // 统一特殊符号Ⅹ为X
        employeeList.add(new String[]{"长治业务中心", "陈佳琪", "女", "140402199503102823", "13994634845"});
        employeeList.add(new String[]{"长治业务中心", "王志立", "男", "140426197809181212", "13623551981"});
        employeeList.add(new String[]{"长治业务中心", "李信", "男", "14042619951005201X", "17636347995"});
        employeeList.add(new String[]{"长治业务中心", "张慧东", "男", "140426199807050015", "13007062713"});
        employeeList.add(new String[]{"长治业务中心", "王龙祥", "男", "140402200011042014", "18835562255"});
        employeeList.add(new String[]{"长治业务中心", "马超凡", "男", "140481200303243614", "17735514538"});
        employeeList.add(new String[]{"长治业务中心", "赵鑫", "男", "140428200301229278", "15735553696"});
        employeeList.add(new String[]{"长治业务中心", "郭云飞", "女", "140411200208256020", "17735191089"});
        employeeList.add(new String[]{"长治业务中心", "张荣光", "男", "140402198109211218", "15234556365"});
        employeeList.add(new String[]{"长治业务中心", "孙晨晨", "男", "140411199809244011", "14703554959"});
        employeeList.add(new String[]{"长治业务中心", "马琪奥", "男", "140402200101194038", "15713551111"});
        employeeList.add(new String[]{"长治业务中心", "贾小平", "男", "140424196111250012", "13935525853"});
        employeeList.add(new String[]{"长治业务中心", "王子涵", "男", "140402200111112411", "15034500606"});
        employeeList.add(new String[]{"长治业务中心", "杜青山", "男", "140421196311022816", "13513559365"});
        employeeList.add(new String[]{"长治业务中心", "郎志浩", "男", "140426196101160016", "18003559321"});
        employeeList.add(new String[]{"长治业务中心", "李强", "男", "140402197710160816", "13835522468"});
        employeeList.add(new String[]{"长治业务中心", "上官斌斌", "男", "140402199406293234", "15383557272"});
        employeeList.add(new String[]{"长治业务中心", "王建兵", "男", "140427196505043613", "13994698399"});



        return employeeList;
    }

    private List<String> summaryDeptCount() {
        // 1. 定义所有部门列表（按提供的顺序整理，去重前完整列表）
        List<String> allDepts = Arrays.asList(
                "公司领导", "公司领导", "公司领导", "公司领导",
                "综合管理部",
                "太原业务中心", "太原业务中心", "太原业务中心", "太原业务中心",
                "长治业务中心",
                "运城业务中心",
                "晋中业务中心",
                "阳泉业务中心",
                "临汾业务中心",
                "吕梁业务中心",
                "党建部",
                "财务资产部",
                "忻州业务中心",
                "长治业务中心",
                "太原业务中心",
                "安全监察部",
                "经营管理部",
                "太原业务中心", "太原业务中心", "太原业务中心", "太原业务中心",
                "晋中业务中心",
                "晋城业务中心",
                "忻州业务中心",
                "临汾业务中心",
                "晋中业务中心",
                "吕梁业务中心", "吕梁业务中心",
                "太原业务中心", "太原业务中心",
                "吕梁业务中心",
                "忻州业务中心",
                "财务资产部",
                "人力资源部",
                "经营管理部",
                "安全监察部",
                "工程技术部", "工程技术部",
                "经营管理部", "经营管理部",
                "阳泉业务中心",
                "运城业务中心", "运城业务中心",
                "综合管理部",
                "太原业务中心",
                "经营管理部",
                "人力资源部",
                "长治业务中心",
                "临汾业务中心",
                "晋中业务中心",
                "大同业务中心",
                "安全监察部", "安全监察部",
                "财务资产部",
                "长治业务中心",
                "运城业务中心",
                "太原业务中心",
                "综合管理部",
                "财务资产部",
                "太原业务中心",
                "综合管理部",
                "党建部", "党建部",
                "综合管理部",
                "党建部",
                "综合管理部", "综合管理部",
                "人力资源部", "人力资源部",
                "经营管理部", "经营管理部",
                "安全监察部",
                "工程技术部", "工程技术部", "工程技术部",
                "综合管理部",
                "党建部",
                "综合管理部",
                "大同业务中心",
                "晋城业务中心",
                "晋中业务中心",
                "临汾业务中心",
                "吕梁业务中心",
                "朔州业务中心",
                "太原业务中心",
                "忻州业务中心",
                "阳泉业务中心",
                "运城业务中心",
                "长治业务中心"
        );


        return allDepts.stream().distinct().collect(Collectors.toList());
    }

    @Transactional(rollbackFor = Exception.class)
    @GetMapping("/sync_data")
    public R syncData() {

/*
        List<String> deptList = summaryDeptCount();

        for (String deptName : deptList) {

            SysDept querySysDept = new SysDept();
            querySysDept.setDeptName(deptName);
            List<SysDept> sysDepts = sysDeptMapper.selectDeptList(querySysDept);

            if (CollUtil.isNotEmpty(sysDepts)){
                continue;
            }

            Integer maxSort = sysDeptMapper.selectMaxSort();

            SysDept sysDept = new SysDept();
            sysDept.setOrderNum(maxSort+1);
            sysDept.setDeptName(deptName);
            sysDept.setStatus("0");
            sysDept.setDelFlag("0");
            sysDept.setAncestors("0,100");
            sysDept.setParentId(100L);

            sysDeptMapper.insertDept(sysDept);
        }
*/

        Set<String> deptLists = new HashSet<>();

        List<String[]> employeeArrayList = buildEmployeeArrayList();
        for (String[] employee : employeeArrayList) {
            String deptName = employee[0]; // 部门/地市
            String name = employee[1];     // 姓名
            String gender = employee[2];   // 性别
            String idCard = employee[3];   // 身份证号
            String phone = employee[4];    // 手机号


            SysDept querySysDept = new SysDept();
            querySysDept.setDeptName(deptName);
            List<SysDept> sysDepts = sysDeptMapper.selectDeptList(querySysDept);
            if (CollUtil.isNotEmpty(sysDepts)) {
                SysDept sysDept = sysDepts.get(0);
                Long deptId = sysDept.getDeptId();

                SysRole querySysRole = new SysRole();
                querySysRole.setRoleName(deptName);
                List<SysRole> sysRoles = sysRoleMapper.selectRoleList(querySysRole);

                if (CollUtil.isEmpty(sysRoles)){
                    deptLists.add(deptName);
                }

                SysRole sysRole = sysRoles.get(0);
                Long roleId = sysRole.getRoleId();


                SysUser querySysUser = new SysUser();
                querySysUser.setNickName(name);
                List<SysUser> sysUsers = sysUserMapper.selectUserList(querySysUser);
                if (CollUtil.isNotEmpty(sysUsers)) {

                    SysUser user = sysUsers.get(0);
                    Long userId = user.getUserId();
                    user.setPhonenumber(phone);
                    user.setNickName(name);
                    user.setIdCard(idCard);
                    user.setDeptId(deptId);
                    user.setStatus("0");
                    user.setDelFlag("0");
                    if ("男".equals(gender)) {
                        user.setSex("0");
                    } else if ("女".equals(gender)) {
                        user.setSex("1");
                    }
                    user.setPhonenumber(phone);
                    user.setUserName(phone);

                    sysUserMapper.updateUser(user);


                    int i = sysUserRoleMapper.selectRoleIdUserId(roleId, userId);
                    if (i == 0) {
                        SysUserRole sysUserRole = new SysUserRole();
                        sysUserRole.setRoleId(roleId);
                        sysUserRole.setUserId(userId);
                        sysUserRoleMapper.insert(sysUserRole);
                    }


                } else {

                    SysUser insertUser = new SysUser();
                    insertUser.setNickName(name);
                    insertUser.setDeptId(deptId);
                    insertUser.setStatus("0");
                    insertUser.setDelFlag("0");
                    insertUser.setIdCard(idCard);
                    if ("男".equals(gender)) {
                        insertUser.setSex("0");
                    } else if ("女".equals(gender)) {
                        insertUser.setSex("1");
                    }
                    insertUser.setPhonenumber(phone);
                    insertUser.setUserName(phone);

                    sysUserMapper.insertUser(insertUser);

                }


            }


        }
//        System.out.println(deptLists);
//
//
//        List<Long> menuIdList = sysRoleMenuMapper.selectRoleId(128L);
//
//
//        List<SysRoleMenu> sysRoleMenuList = new ArrayList<>();
//        for (String roleName : deptLists) {
//
//            SysRole insertRole = new SysRole();
//            insertRole.setRoleName(roleName);
//            insertRole.setDataScope("2");
//            insertRole.setMenuCheckStrictly(true);
//            insertRole.setDeptCheckStrictly(true);
//            insertRole.setStatus("0");
//            insertRole.setDelFlag("0");
//            insertRole.setRoleKey(roleName);
//            insertRole.setRoleSort(99);
//
//            sysRoleMapper.insertRole(insertRole);
//
//
//
//            for (Long menuId : menuIdList) {
//
//                SysRoleMenu sysRoleMenu = new SysRoleMenu();
//                sysRoleMenu.setRoleId(insertRole.getRoleId());
//                sysRoleMenu.setMenuId(menuId);
//
//                sysRoleMenuList.add(sysRoleMenu);
//            }
//
//        }
//
//        sysRoleMenuMapper.batchRoleMenu(sysRoleMenuList);




        return R.ok();
    }


    @Operation(summary = "获取用户列表")
    @GetMapping("/list")
    public R<List<UserEntity>> userList() {
        List<UserEntity> userList = new ArrayList<UserEntity>(users.values());
        return R.ok(userList);
    }

    @Operation(summary = "获取用户详细")
    @GetMapping("/{userId}")
    public R<UserEntity> getUser(@PathVariable(name = "userId")
                                 Integer userId) {
        if (!users.isEmpty() && users.containsKey(userId)) {
            return R.ok(users.get(userId));
        } else {
            return R.fail("用户不存在");
        }
    }

    @Operation(summary = "新增用户")
    @PostMapping("/save")
    public R<String> save(UserEntity user) {
        if (StringUtils.isNull(user) || StringUtils.isNull(user.getUserId())) {
            return R.fail("用户ID不能为空");
        }
        users.put(user.getUserId(), user);
        return R.ok();
    }

    @Operation(summary = "更新用户")
    @PutMapping("/update")
    public R<String> update(@RequestBody
                            UserEntity user) {
        if (StringUtils.isNull(user) || StringUtils.isNull(user.getUserId())) {
            return R.fail("用户ID不能为空");
        }
        if (users.isEmpty() || !users.containsKey(user.getUserId())) {
            return R.fail("用户不存在");
        }
        users.remove(user.getUserId());
        users.put(user.getUserId(), user);
        return R.ok();
    }

    @Operation(summary = "删除用户信息")
    @DeleteMapping("/{userId}")
    public R<String> delete(@PathVariable(name = "userId")
                            Integer userId) {
        if (!users.isEmpty() && users.containsKey(userId)) {
            users.remove(userId);
            return R.ok();
        } else {
            return R.fail("用户不存在");
        }
    }
}

@Schema(description = "用户实体")
class UserEntity {
    @Schema(title = "用户ID")
    private Integer userId;

    @Schema(title = "用户名称")
    private String username;

    @Schema(title = "用户密码")
    private String password;

    @Schema(title = "用户手机")
    private String mobile;

    public UserEntity() {

    }

    public UserEntity(Integer userId, String username, String password, String mobile) {
        this.userId = userId;
        this.username = username;
        this.password = password;
        this.mobile = mobile;
    }

    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }
}
